package com.corpgovernment.travelstandard.impl;

import com.corpgovernment.api.travelstandard.enums.AreaTypeEnum;
import com.corpgovernment.api.travelstandard.service.IAreaConfigService;
import com.corpgovernment.api.travelstandard.vo.*;
import com.corpgovernment.basicdata.bo.HotelCityBo;
import com.corpgovernment.basicdata.service.impl.HotelCityDataService;
import com.corpgovernment.common.base.Page;
import com.corpgovernment.common.common.CorpBusinessException;
import com.corpgovernment.common.enums.ExceptionCodeEnum;
import com.corpgovernment.common.utils.ListUtils;
import com.corpgovernment.common.utils.ObjectUtils;
import com.corpgovernment.common.utils.PageUtils;
import com.corpgovernment.organization.constant.OrganizationResponseCodeEnum;
import com.corpgovernment.travelstandard.entity.db.TravelStandardAreaConfig;
import com.corpgovernment.travelstandard.mapper.AreaConfigMapper;
import com.ctrip.corp.obt.generic.utils.CollectionUtils;
import com.ctrip.corp.obt.generic.utils.JsonUtils;
import com.ctrip.corp.obt.shard.context.PageContext;
import com.google.common.collect.Lists;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.math.NumberUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.*;
import java.util.stream.Collectors;

@Service
@Slf4j
public class AreaConfigService extends TravelStandardBaseService implements IAreaConfigService {

    private static String[] SPECIAL_AREA_NAME = {"国内其它城市", "国内其他城市", "国内城市"};

    @Autowired
    private AreaConfigMapper areaConfigMapper;
    @Autowired
    private CityConfigService cityConfigService;
    @Autowired
    private MbTravelstandHotelPriceService travelstandHotelPriceService;
    @Autowired
    private MbTravelstandHotelQuarterService travelstandHotelQuarterService;
    @Autowired
    private MbTravelstandHotelService mbTravelstandHotelService;
    @Autowired
    private HotelCityDataService hotelCityDataService;

    @Override
    public void insert(AreaConfigVo model) {
        TravelStandardAreaConfig travelStandardAreaConfig = ObjectUtils.copyProperties(model, TravelStandardAreaConfig.class);
        areaConfigMapper.insertSelective(travelStandardAreaConfig);
        insertOperateLog(travelStandardAreaConfig);
    }


    @Override
    public int delete(Long id) {
        deleteOperateLog(String.valueOf(id));
        return areaConfigMapper.deleteByPrimaryKey(id);
    }

    @Override
    public int update(AreaConfigVo model) {
        TravelStandardAreaConfig travelStandardAreaConfig = ObjectUtils.copyProperties(model, TravelStandardAreaConfig.class);
        try {
            TravelStandardAreaConfig oldValue = findById(model.getId());
            updateOperateLog(oldValue, travelStandardAreaConfig);
        } catch (Exception e) {
            log.error("更新操作获取查询失败,AreaConfigService.update");
        }
        return areaConfigMapper.updateByPrimaryKeySelective(travelStandardAreaConfig);
    }

    private TravelStandardAreaConfig findById(Long id) {
        TravelStandardAreaConfig result = areaConfigMapper.selectByPrimaryKey(id);
        if (result == null || result.getStatus() != 0) {
            return null;
        }
        return result;
    }

    @Override
    public AreaConfigVo get(Long id) {
        return ObjectUtils.copyProperties(findById(id), AreaConfigVo.class);
    }

    @Override
    public List<AreaVo> getAreaConfigList(AreaConfigVo areaConfigVo) {
        TravelStandardAreaConfig config = new TravelStandardAreaConfig();
        config.setOrgId(areaConfigVo.getOrgId());
        config.setStatus(areaConfigVo.getStatus());
        config.setAreaType(areaConfigVo.getAreaType());
        config.setHotelType(areaConfigVo.getHotelType());
        List<TravelStandardAreaConfig> areaConfigList = areaConfigMapper.list(config);
        List<AreaVo> list = Lists.newArrayList();
        AreaVo areaVo;
        if (!CollectionUtils.isEmpty(areaConfigList)) {
            for (TravelStandardAreaConfig areaConfig : areaConfigList) {
                areaVo = new AreaVo();
                areaVo.setId(areaConfig.getId());
                areaVo.setName(areaConfig.getAreaName());
                areaVo.setHotelType(areaConfig.getHotelType());
                list.add(areaVo);
            }
        }
        return list;
    }

    @Override
    public Map getAreaDefaultCity(String orgId) {

        AreaConfigVo areaConfigVo = new AreaConfigVo();
        areaConfigVo.setOrgId(orgId);
        areaConfigVo.setStatus(NumberUtils.INTEGER_ZERO);
        areaConfigVo.setAreaType(AreaTypeEnum.TYPE_0.getCode());
        List<AreaVo> areaVoList = this.getAreaConfigList(areaConfigVo);

        boolean hotelResult = areaVoList.stream().anyMatch(e -> AreaTypeEnum.HOTEL_TYPE_0.getCode().equals(e.getHotelType()));

        //国内酒店初始化
        if(!hotelResult){
            areaConfigVo.setStatus(NumberUtils.INTEGER_ONE);
            List<AreaVo> areaConfigList = this.getAreaConfigList(areaConfigVo);
            boolean hotelOtherResult = areaConfigList.stream().anyMatch(e -> AreaTypeEnum.HOTEL_TYPE_0.getCode().equals(e.getHotelType()));
            if(!hotelOtherResult){
                this.initAreaData(orgId);
            }
        }

        //查看有没有 海外其他城市-----初始化
        areaConfigVo.setStatus(NumberUtils.INTEGER_ZERO);
        areaConfigVo.setAreaType(AreaTypeEnum.TYPE_1.getCode());
        areaConfigVo.setHotelType(AreaTypeEnum.HOTEL_TYPE_1.getCode());
        List<AreaVo> areaIntlVoList = this.getAreaConfigList(areaConfigVo);
        if(areaIntlVoList == null || areaIntlVoList.size()==0){
            this.initIntlAreaData(orgId);
        }

        AreaConfigVo searchVo = new AreaConfigVo();
        searchVo.setOrgId(orgId);
        searchVo.setStatus(NumberUtils.INTEGER_ZERO);
        searchVo.setAreaType(AreaTypeEnum.TYPE_0.getCode());
        //查询最新数据
        areaVoList = this.getAreaConfigList(searchVo);
        List<AreaVo> resultList = new ArrayList<>();
        resultList.addAll(areaVoList.stream().filter(t -> AreaTypeEnum.HOTEL_TYPE_0.getCode().equals(t.getHotelType())).collect(Collectors.toList()));
        resultList.addAll(areaVoList.stream().filter(t -> AreaTypeEnum.HOTEL_TYPE_1.getCode().equals(t.getHotelType())).collect(Collectors.toList()));

        Map jsonObject = new HashMap<>();
        jsonObject.put("defaultCity",resultList);
        return jsonObject;
    }

    @Override
    public int updateStatus(AreaConfigVo areaConfigVo) {
        deleteOperateLog(String.valueOf(areaConfigVo.getId()));
        TravelStandardAreaConfig travelStandardAreaConfig = ObjectUtils.copyProperties(areaConfigVo, TravelStandardAreaConfig.class);
        return areaConfigMapper.updateStatus(travelStandardAreaConfig);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public AreaConfigVo saveOrUpdate(Object id, String orgId, String name, String hotelType) {
        AreaConfigVo areaConfigVo = new AreaConfigVo();
        TravelStandardAreaConfig saveOrupdate;
        //修改
        if (id != null) {
//            TravelStandardPostVo postVo = new TravelStandardPostVo();
//            postVo.setAreaId(Integer.parseInt(id.toString()));
//            postVo.setOrgid(orgId);
//            List<MbTravelstandHotelPriceVo> travelstandHotelPriceVos = travelstandHotelPriceService.list(new MbTravelstandHotelPriceVo(){{setTsHotelAreaId(Long.valueOf(Long.valueOf(id.toString())));}});
//            if (travelstandHotelPriceVos.size() > 0) {
//                throw new CorpBusinessException(ExceptionCodeEnum.Alert, "该区域已被酒店差标使用，不可修改!");
//            }
            TravelStandardAreaConfig areaConfig = findById(Long.parseLong(id.toString()));
            if (areaConfig == null) {
                throw new CorpBusinessException(OrganizationResponseCodeEnum.AREA_CONFIG_IS_NULL);
            }
            //判断非法名称
            for (String specialName : SPECIAL_AREA_NAME) {
                if (name.equals(specialName)) {
                    throw new CorpBusinessException(OrganizationResponseCodeEnum.PARAMS_ERROR);
                }
            }
            //如果修改的地区名称与当前的地区名称不相同，查询数据库其他区域是否存在相同的名称
            if (!name.equals(areaConfig.getAreaName())) {
                TravelStandardAreaConfig config = new TravelStandardAreaConfig();
                config.setAreaName(name);
                config.setOrgId(orgId);
                int count = areaConfigMapper.existName(config);
                if (count > NumberUtils.INTEGER_ZERO) {
                    throw new CorpBusinessException(OrganizationResponseCodeEnum.NAME_EXISTS);
                }
                saveOrupdate = new TravelStandardAreaConfig();
                saveOrupdate.setId(Long.parseLong(id.toString()));
                saveOrupdate.setAreaName(name);
                areaConfigMapper.updateByPrimaryKeySelective(saveOrupdate);
                try {
                    TravelStandardAreaConfig oldValue = findById(Long.parseLong(id.toString()));
                    updateOperateLog(oldValue, saveOrupdate);
                } catch (NumberFormatException e) {
                    log.error("更新操作获取查询失败,AreaConfigService.saveOrUpdate");
                }
                areaConfigVo = ObjectUtils.copyProperties(saveOrupdate, AreaConfigVo.class);
            }
        }
        //新增
        else {
            //判断非法名称
            for (String specialName : SPECIAL_AREA_NAME) {
                if (name.equals(specialName)) {
                    throw new CorpBusinessException(OrganizationResponseCodeEnum.NAME_EXISTS);
                }
            }
            //判断是否存在相同的名称
            TravelStandardAreaConfig config = new TravelStandardAreaConfig();
            config.setAreaName(name);
            config.setAreaType(AreaTypeEnum.TYPE_0.getCode());
            config.setOrgId(orgId);
            int count = areaConfigMapper.existName(config);
            if (count > NumberUtils.INTEGER_ZERO.intValue()) {
                throw new CorpBusinessException(OrganizationResponseCodeEnum.NAME_EXISTS);
            }
            //插入地区
            saveOrupdate = new TravelStandardAreaConfig();
            saveOrupdate.setOrgId(orgId);
            saveOrupdate.setAreaName(name);
            saveOrupdate.setAreaType(AreaTypeEnum.TYPE_0.getCode());
            saveOrupdate.setHotelType(hotelType);
            areaConfigMapper.insertSelective(saveOrupdate);
            insertOperateLog(saveOrupdate);
            areaConfigVo = ObjectUtils.copyProperties(saveOrupdate, AreaConfigVo.class);
            //将新的地区限价信息、淡旺季信息插入所有已存在的差标
            List<MbTravelstandHotelVo> mbTravelstandHotelVos = mbTravelstandHotelService.list(new MbTravelstandHotelVo() {{
                setOrgId(orgId);
            }});
            for (MbTravelstandHotelVo mbTravelstandHotelVo : mbTravelstandHotelVos) {
                //限价信息
                MbTravelstandHotelPriceVo mbTravelstandHotelPriceVo = new MbTravelstandHotelPriceVo();
                mbTravelstandHotelPriceVo.setTsHotelId(mbTravelstandHotelVo.getId());
                mbTravelstandHotelPriceVo.setTsHotelAreaId(saveOrupdate.getId());
                travelstandHotelPriceService.insert(mbTravelstandHotelPriceVo);
                //淡旺季信息
                MbTravelstandHotelQuarterVo mbTravelstandHotelQuarterVo = new MbTravelstandHotelQuarterVo();
                mbTravelstandHotelQuarterVo.setTsHotelId(mbTravelstandHotelVo.getId());
                mbTravelstandHotelQuarterVo.setTsHotelAreaId(saveOrupdate.getId());
                travelstandHotelQuarterService.insert(mbTravelstandHotelQuarterVo);
            }
            //将当前组织下的【其它地区】类型的地区改名为"国内其它城市"
            if(AreaTypeEnum.HOTEL_TYPE_0.getCode().equals(hotelType)){
                areaConfigMapper.updateAreaNameByOrgIdAndAreaType("国内其它城市", orgId, AreaTypeEnum.TYPE_1.getCode(),hotelType);
            }else{
                areaConfigMapper.updateAreaNameByOrgIdAndAreaType("海外其它城市", orgId, AreaTypeEnum.TYPE_1.getCode(),hotelType);
            }

        }
        return areaConfigVo;
    }

    @Override
    public List<AllCityConfigVo> queryAllCityConfig(QueryCitysVo citysVo) {
        List<TravelStandardAreaConfig> list = areaConfigMapper.listByOrgIdAreaId(citysVo);
        if (CollectionUtils.isEmpty(list)) {
            return new ArrayList<>();
        }
        return list.stream().filter(Objects::nonNull).map(tsac -> {
            AllCityConfigVo temp = new AllCityConfigVo();
            temp.setId(tsac.getId());
            temp.setAreaName(tsac.getAreaName());
            temp.setCitys(tsac.getCitys());
            return temp;
        }).collect(Collectors.toList());
    }

    @Override
    public SelectCityVo getCityConfigSelectByareaId(QueryCitysVo citysVo) {
        TravelStandardAreaConfig result= areaConfigMapper. findByAreaId(citysVo);
        if(result==null){
            return null;
        }
        SelectCityVo cityVo=new SelectCityVo();
        cityVo.setCitys(result.getCitys());
        return cityVo;
    }

    public static void main(String[] args) {
        String zxs = "重庆、天津、北京、上海";
        String shcs = "石家庄、太原、呼和浩特、沈阳、长春、哈尔滨、南京、杭州、合肥、福州、南昌、郑州、济南、武汉、长沙、广州、南宁、海口、成都、贵阳、昆明、拉萨、西安、兰州、银川、西宁、乌鲁木齐";
        String jhdls = "大连、厦门、宁波、青岛、深圳";
        String data = "{\"citys\":[{\"area_id\":1,\"cityAbbreviation\":\"BJ\",\"cityPinyin\":\"beijing\",\"city_code\":\"1\",\"city_name\":\"北京\",\"city_name_en\":\"B\"},{\"area_id\":1,\"cityAbbreviation\":\"SH\",\"cityPinyin\":\"shanghai\",\"city_code\":\"2\",\"city_name\":\"上海\",\"city_name_en\":\"S\"},{\"area_id\":1,\"cityAbbreviation\":\"CQ\",\"cityPinyin\":\"CQ\",\"city_code\":\"4\",\"city_name\":\"重庆\",\"city_name_en\":\"C\"},{\"area_id\":1,\"cityAbbreviation\":\"TJ\",\"cityPinyin\":\"tianjin\",\"city_code\":\"3\",\"city_name\":\"天津\",\"city_name_en\":\"T\"},{\"area_id\":2,\"cityAbbreviation\":\"HZ\",\"cityPinyin\":\"hangzhou\",\"city_code\":\"17\",\"city_name\":\"杭州\",\"city_name_en\":\"H\"},{\"area_id\":2,\"cityAbbreviation\":\"NJ\",\"cityPinyin\":\"nanjing\",\"city_code\":\"12\",\"city_name\":\"南京\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"JN\",\"cityPinyin\":\"jinan\",\"city_code\":\"144\",\"city_name\":\"济南\",\"city_name_en\":\"J\"},{\"area_id\":1,\"cityAbbreviation\":\"GZ\",\"cityPinyin\":\"guangzhou\",\"city_code\":\"32\",\"city_name\":\"广州\",\"city_name_en\":\"G\"},{\"area_id\":1,\"cityAbbreviation\":\"SZ\",\"cityPinyin\":\"shenzhen\",\"city_code\":\"30\",\"city_name\":\"深圳\",\"city_name_en\":\"S\"},{\"area_id\":2,\"cityAbbreviation\":\"QD\",\"cityPinyin\":\"qingdao\",\"city_code\":\"7\",\"city_name\":\"青岛\",\"city_name_en\":\"Q\"},{\"area_id\":2,\"cityAbbreviation\":\"DL\",\"cityPinyin\":\"dalian\",\"city_code\":\"6\",\"city_name\":\"大连\",\"city_name_en\":\"D\"},{\"area_id\":2,\"cityAbbreviation\":\"NB\",\"cityPinyin\":\"ningbo\",\"city_code\":\"375\",\"city_name\":\"宁波\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"XM\",\"cityPinyin\":\"xiamen\",\"city_code\":\"26\",\"city_name\":\"厦门\",\"city_name_en\":\"X\"},{\"area_id\":2,\"cityAbbreviation\":\"CD\",\"cityPinyin\":\"chengdou\",\"city_code\":\"28\",\"city_name\":\"成都\",\"city_name_en\":\"C\"},{\"area_id\":2,\"cityAbbreviation\":\"WH\",\"cityPinyin\":\"wuhan\",\"city_code\":\"477\",\"city_name\":\"武汉\",\"city_name_en\":\"W\"},{\"area_id\":2,\"cityAbbreviation\":\"HEB\",\"cityPinyin\":\"haerbin\",\"city_code\":\"5\",\"city_name\":\"哈尔滨\",\"city_name_en\":\"H\"},{\"area_id\":2,\"cityAbbreviation\":\"SY\",\"cityPinyin\":\"shenyang\",\"city_code\":\"451\",\"city_name\":\"沈阳\",\"city_name_en\":\"S\"},{\"area_id\":2,\"cityAbbreviation\":\"XA\",\"cityPinyin\":\"xian\",\"city_code\":\"10\",\"city_name\":\"西安\",\"city_name_en\":\"X\"},{\"area_id\":2,\"cityAbbreviation\":\"ZC\",\"cityPinyin\":\"zhangchun\",\"city_code\":\"158\",\"city_name\":\"长春\",\"city_name_en\":\"C\"},{\"area_id\":2,\"cityAbbreviation\":\"ZS\",\"cityPinyin\":\"zhangsha\",\"city_code\":\"206\",\"city_name\":\"长沙\",\"city_name_en\":\"C\"},{\"area_id\":2,\"cityAbbreviation\":\"FZ\",\"cityPinyin\":\"fuzhou\",\"city_code\":\"258\",\"city_name\":\"福州\",\"city_name_en\":\"F\"},{\"area_id\":2,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zhengzhou\",\"city_code\":\"559\",\"city_name\":\"郑州\",\"city_name_en\":\"Z\"},{\"area_id\":2,\"cityAbbreviation\":\"SJZ\",\"cityPinyin\":\"shijiazhuang\",\"city_code\":\"428\",\"city_name\":\"石家庄\",\"city_name_en\":\"S\"},{\"area_id\":2,\"cityAbbreviation\":\"SZ\",\"cityPinyin\":\"suzhou\",\"city_code\":\"14\",\"city_name\":\"苏州\",\"city_name_en\":\"S\"},{\"area_id\":2,\"cityAbbreviation\":\"FS\",\"cityPinyin\":\"foshan\",\"city_code\":\"251\",\"city_name\":\"佛山\",\"city_name_en\":\"F\"},{\"area_id\":2,\"cityAbbreviation\":\"DG\",\"cityPinyin\":\"dongguan\",\"city_code\":\"223\",\"city_name\":\"东莞\",\"city_name_en\":\"D\"},{\"area_id\":2,\"cityAbbreviation\":\"WX\",\"cityPinyin\":\"wuxi\",\"city_code\":\"13\",\"city_name\":\"无锡\",\"city_name_en\":\"W\"},{\"area_id\":2,\"cityAbbreviation\":\"YT\",\"cityPinyin\":\"yantai\",\"city_code\":\"533\",\"city_name\":\"烟台\",\"city_name_en\":\"Y\"},{\"area_id\":2,\"cityAbbreviation\":\"TY\",\"cityPinyin\":\"taiyuan\",\"city_code\":\"105\",\"city_name\":\"太原\",\"city_name_en\":\"T\"},{\"area_id\":2,\"cityAbbreviation\":\"HF\",\"cityPinyin\":\"hefei\",\"city_code\":\"278\",\"city_name\":\"合肥\",\"city_name_en\":\"H\"},{\"area_id\":2,\"cityAbbreviation\":\"NC\",\"cityPinyin\":\"nanchang\",\"city_code\":\"376\",\"city_name\":\"南昌\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"NN\",\"cityPinyin\":\"nanning\",\"city_code\":\"380\",\"city_name\":\"南宁\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"KM\",\"cityPinyin\":\"kunming\",\"city_code\":\"34\",\"city_name\":\"昆明\",\"city_name_en\":\"K\"},{\"area_id\":2,\"cityAbbreviation\":\"WZ\",\"cityPinyin\":\"wenzhou\",\"city_code\":\"491\",\"city_name\":\"温州\",\"city_name_en\":\"W\"},{\"area_id\":2,\"cityAbbreviation\":\"ZB\",\"cityPinyin\":\"zibo\",\"city_code\":\"542\",\"city_name\":\"淄博\",\"city_name_en\":\"Z\"},{\"area_id\":2,\"cityAbbreviation\":\"TS\",\"cityPinyin\":\"tangshan\",\"city_code\":\"468\",\"city_name\":\"唐山\",\"city_name_en\":\"T\"},{\"area_id\":3,\"cityAbbreviation\":\"WLMQ\",\"cityPinyin\":\"wulumuqi\",\"city_code\":\"39\",\"city_name\":\"乌鲁木齐\",\"city_name_en\":\"W\"},{\"area_id\":3,\"cityAbbreviation\":\"GY\",\"cityPinyin\":\"guiyang\",\"city_code\":\"38\",\"city_name\":\"贵阳\",\"city_name_en\":\"G\"},{\"area_id\":3,\"cityAbbreviation\":\"HK\",\"cityPinyin\":\"haikou\",\"city_code\":\"42\",\"city_name\":\"海口\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"LZ\",\"cityPinyin\":\"lanzhou\",\"city_code\":\"100\",\"city_name\":\"兰州\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yinchuan\",\"city_code\":\"99\",\"city_name\":\"银川\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"XN\",\"cityPinyin\":\"xining\",\"city_code\":\"124\",\"city_name\":\"西宁\",\"city_name_en\":\"X\"},{\"area_id\":3,\"cityAbbreviation\":\"HHHT\",\"cityPinyin\":\"huhehaote\",\"city_code\":\"103\",\"city_name\":\"呼和浩特\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"QZ\",\"cityPinyin\":\"quanzhou\",\"city_code\":\"406\",\"city_name\":\"泉州\",\"city_name_en\":\"Q\"},{\"area_id\":3,\"cityAbbreviation\":\"BT\",\"cityPinyin\":\"baotou\",\"city_code\":\"141\",\"city_name\":\"包头\",\"city_name_en\":\"B\"},{\"area_id\":3,\"cityAbbreviation\":\"NT\",\"cityPinyin\":\"nantong\",\"city_code\":\"82\",\"city_name\":\"南通\",\"city_name_en\":\"N\"},{\"area_id\":3,\"cityAbbreviation\":\"DQ\",\"cityPinyin\":\"daqing\",\"city_code\":\"231\",\"city_name\":\"大庆\",\"city_name_en\":\"D\"},{\"area_id\":3,\"cityAbbreviation\":\"XZ\",\"cityPinyin\":\"xuzhou\",\"city_code\":\"512\",\"city_name\":\"徐州\",\"city_name_en\":\"X\"},{\"area_id\":3,\"cityAbbreviation\":\"WF\",\"cityPinyin\":\"weifang\",\"city_code\":\"475\",\"city_name\":\"潍坊\",\"city_name_en\":\"W\"},{\"area_id\":3,\"cityAbbreviation\":\"CZ\",\"cityPinyin\":\"changzhou\",\"city_code\":\"213\",\"city_name\":\"常州\",\"city_name_en\":\"C\"},{\"area_id\":3,\"cityAbbreviation\":\"EEDS\",\"cityPinyin\":\"eerduosi\",\"city_code\":\"3976\",\"city_name\":\"鄂尔多斯\",\"city_name_en\":\"E\"},{\"area_id\":3,\"cityAbbreviation\":\"SX\",\"cityPinyin\":\"shaoxing\",\"city_code\":\"22\",\"city_name\":\"绍兴\",\"city_name_en\":\"S\"},{\"area_id\":3,\"cityAbbreviation\":\"JN\",\"cityPinyin\":\"jining\",\"city_code\":\"318\",\"city_name\":\"济宁\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yancheng\",\"city_code\":\"1200\",\"city_name\":\"盐城\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"HD\",\"cityPinyin\":\"handan\",\"city_code\":\"275\",\"city_name\":\"邯郸\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"LY\",\"cityPinyin\":\"linyi\",\"city_code\":\"569\",\"city_name\":\"临沂\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"LY\",\"cityPinyin\":\"luoyang\",\"city_code\":\"350\",\"city_name\":\"洛阳\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"DY\",\"cityPinyin\":\"dongying\",\"city_code\":\"236\",\"city_name\":\"东营\",\"city_name_en\":\"D\"},{\"area_id\":3,\"cityAbbreviation\":\"YZ\",\"cityPinyin\":\"yangzhou\",\"city_code\":\"15\",\"city_name\":\"扬州\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"TZ\",\"cityPinyin\":\"taizhou\",\"city_code\":\"578\",\"city_name\":\"台州\",\"city_name_en\":\"T\"},{\"area_id\":3,\"cityAbbreviation\":\"JX\",\"cityPinyin\":\"jiaxing\",\"city_code\":\"571\",\"city_name\":\"嘉兴\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"CZ\",\"cityPinyin\":\"cangzhou\",\"city_code\":\"216\",\"city_name\":\"沧州\",\"city_name_en\":\"C\"},{\"area_id\":3,\"cityAbbreviation\":\"YL\",\"cityPinyin\":\"yulin\",\"city_code\":\"527\",\"city_name\":\"榆林\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"TZ\",\"cityPinyin\":\"taizhou\",\"city_code\":\"579\",\"city_name\":\"泰州\",\"city_name_en\":\"T\"},{\"area_id\":3,\"cityAbbreviation\":\"ZJ\",\"cityPinyin\":\"zhenjiang\",\"city_code\":\"16\",\"city_name\":\"镇江\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"KS\",\"cityPinyin\":\"kunshan\",\"city_code\":\"83\",\"city_name\":\"昆山\",\"city_name_en\":\"K\"},{\"area_id\":3,\"cityAbbreviation\":\"JY\",\"cityPinyin\":\"jiangyin\",\"city_code\":\"325\",\"city_name\":\"江阴\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"ZJG\",\"cityPinyin\":\"zhangjiagang\",\"city_code\":\"621\",\"city_name\":\"张家港\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"YW\",\"cityPinyin\":\"yiwu\",\"city_code\":\"536\",\"city_name\":\"义乌\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"JH\",\"cityPinyin\":\"jinhua\",\"city_code\":\"308\",\"city_name\":\"金华\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"BD\",\"cityPinyin\":\"baoding\",\"city_code\":\"185\",\"city_name\":\"保定\",\"city_name_en\":\"B\"},{\"area_id\":3,\"cityAbbreviation\":\"JL\",\"cityPinyin\":\"jilin\",\"city_code\":\"159\",\"city_name\":\"吉林\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"AS\",\"cityPinyin\":\"anshan\",\"city_code\":\"178\",\"city_name\":\"鞍山\",\"city_name_en\":\"A\"},{\"area_id\":3,\"cityAbbreviation\":\"TA\",\"cityPinyin\":\"taian\",\"city_code\":\"454\",\"city_name\":\"泰安\",\"city_name_en\":\"T\"},{\"area_id\":3,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yichang\",\"city_code\":\"515\",\"city_name\":\"宜昌\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"XY\",\"cityPinyin\":\"xiangyang\",\"city_code\":\"496\",\"city_name\":\"襄阳\",\"city_name_en\":\"X\"},{\"area_id\":3,\"cityAbbreviation\":\"ZS\",\"cityPinyin\":\"zhongshan\",\"city_code\":\"553\",\"city_name\":\"中山\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"HZ\",\"cityPinyin\":\"huizhou\",\"city_code\":\"299\",\"city_name\":\"惠州\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"NY\",\"cityPinyin\":\"nanyang\",\"city_code\":\"385\",\"city_name\":\"南阳\",\"city_name_en\":\"N\"},{\"area_id\":3,\"cityAbbreviation\":\"WH\",\"cityPinyin\":\"weihai\",\"city_code\":\"479\",\"city_name\":\"威海\",\"city_name_en\":\"W\"},{\"area_id\":3,\"cityAbbreviation\":\"DZ\",\"cityPinyin\":\"dezhou\",\"city_code\":\"1370\",\"city_name\":\"德州\",\"city_name_en\":\"D\"},{\"area_id\":3,\"cityAbbreviation\":\"YY\",\"cityPinyin\":\"yueyang\",\"city_code\":\"539\",\"city_name\":\"岳阳\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"LC\",\"cityPinyin\":\"liaocheng\",\"city_code\":\"1071\",\"city_name\":\"聊城\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"CD\",\"cityPinyin\":\"changde\",\"city_code\":\"201\",\"city_name\":\"常德\",\"city_name_en\":\"C\"},{\"area_id\":3,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zhangzhou\",\"city_code\":\"560\",\"city_name\":\"漳州\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"BZ\",\"cityPinyin\":\"binzhou\",\"city_code\":\"1820\",\"city_name\":\"滨州\",\"city_name_en\":\"B\"},{\"area_id\":3,\"cityAbbreviation\":\"MM\",\"cityPinyin\":\"maoming\",\"city_code\":\"1105\",\"city_name\":\"茂名\",\"city_name_en\":\"M\"},{\"area_id\":3,\"cityAbbreviation\":\"HA\",\"cityPinyin\":\"huaian\",\"city_code\":\"577\",\"city_name\":\"淮安\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"JM\",\"cityPinyin\":\"jiangmen\",\"city_code\":\"316\",\"city_name\":\"江门\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"WH\",\"cityPinyin\":\"wuhu\",\"city_code\":\"478\",\"city_name\":\"芜湖\",\"city_name_en\":\"W\"},{\"area_id\":3,\"cityAbbreviation\":\"ZJ\",\"cityPinyin\":\"zhanjiang\",\"city_code\":\"547\",\"city_name\":\"湛江\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"LF\",\"cityPinyin\":\"langfang\",\"city_code\":\"340\",\"city_name\":\"廊坊\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"HZ\",\"cityPinyin\":\"heze\",\"city_code\":\"1074\",\"city_name\":\"菏泽\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"LZ\",\"cityPinyin\":\"liuzhou\",\"city_code\":\"112\",\"city_name\":\"柳州\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"BJ\",\"cityPinyin\":\"baoji\",\"city_code\":\"354\",\"city_name\":\"宝鸡\",\"city_name_en\":\"B\"},{\"area_id\":3,\"cityAbbreviation\":\"ZH\",\"cityPinyin\":\"zhuhai\",\"city_code\":\"31\",\"city_name\":\"珠海\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"MY\",\"cityPinyin\":\"mianyang\",\"city_code\":\"370\",\"city_name\":\"绵阳\",\"city_name_en\":\"M\"},{\"area_id\":4,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zhuzhou\",\"city_code\":\"601\",\"city_name\":\"株洲\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zaozhuang\",\"city_code\":\"614\",\"city_name\":\"枣庄\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"XC\",\"cityPinyin\":\"xuchang\",\"city_code\":\"1094\",\"city_name\":\"许昌\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"TL\",\"cityPinyin\":\"tongliao\",\"city_code\":\"458\",\"city_name\":\"通辽\",\"city_name_en\":\"T\"},{\"area_id\":4,\"cityAbbreviation\":\"HZ\",\"cityPinyin\":\"huzhou\",\"city_code\":\"86\",\"city_name\":\"湖州\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"XX\",\"cityPinyin\":\"xinxiang\",\"city_code\":\"507\",\"city_name\":\"新乡\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"XY\",\"cityPinyin\":\"xianyang\",\"city_code\":\"111\",\"city_name\":\"咸阳\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"SY\",\"cityPinyin\":\"songyuan\",\"city_code\":\"1303\",\"city_name\":\"松原\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"LYG\",\"cityPinyin\":\"lianyungang\",\"city_code\":\"353\",\"city_name\":\"连云港\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"AY\",\"cityPinyin\":\"anyang\",\"city_code\":\"181\",\"city_name\":\"安阳\",\"city_name_en\":\"A\"},{\"area_id\":4,\"cityAbbreviation\":\"ZK\",\"cityPinyin\":\"zhoukou\",\"city_code\":\"3221\",\"city_name\":\"周口\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"JZ\",\"cityPinyin\":\"jiaozuo\",\"city_code\":\"1093\",\"city_name\":\"焦作\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"CF\",\"cityPinyin\":\"chifeng\",\"city_code\":\"202\",\"city_name\":\"赤峰\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"XT\",\"cityPinyin\":\"xingtai\",\"city_code\":\"947\",\"city_name\":\"邢台\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"CZ\",\"cityPinyin\":\"chenzhou\",\"city_code\":\"612\",\"city_name\":\"郴州\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"SQ\",\"cityPinyin\":\"suqian\",\"city_code\":\"1472\",\"city_name\":\"宿迁\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"GZ\",\"cityPinyin\":\"ganzhou\",\"city_code\":\"268\",\"city_name\":\"赣州\",\"city_name_en\":\"G\"},{\"area_id\":4,\"cityAbbreviation\":\"PDS\",\"cityPinyin\":\"pingdingshan\",\"city_code\":\"3222\",\"city_name\":\"平顶山\",\"city_name_en\":\"P\"},{\"area_id\":4,\"cityAbbreviation\":\"GL\",\"cityPinyin\":\"guilin\",\"city_code\":\"33\",\"city_name\":\"桂林\",\"city_name_en\":\"G\"},{\"area_id\":4,\"cityAbbreviation\":\"ZQ\",\"cityPinyin\":\"zhaoqing\",\"city_code\":\"552\",\"city_name\":\"肇庆\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"QJ\",\"cityPinyin\":\"qujing\",\"city_code\":\"985\",\"city_name\":\"曲靖\",\"city_name_en\":\"Q\"},{\"area_id\":4,\"cityAbbreviation\":\"JJ\",\"cityPinyin\":\"jiujiang\",\"city_code\":\"24\",\"city_name\":\"九江\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"SQ\",\"cityPinyin\":\"shangqiu\",\"city_code\":\"441\",\"city_name\":\"商丘\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"ST\",\"cityPinyin\":\"shantou\",\"city_code\":\"447\",\"city_name\":\"汕头\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"XY\",\"cityPinyin\":\"xinyang\",\"city_code\":\"510\",\"city_name\":\"信阳\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"ZMD\",\"cityPinyin\":\"zhumadian\",\"city_code\":\"551\",\"city_name\":\"驻马店\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"YK\",\"cityPinyin\":\"yingkou\",\"city_code\":\"1300\",\"city_name\":\"营口\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"JY\",\"cityPinyin\":\"jieyang\",\"city_code\":\"956\",\"city_name\":\"揭阳\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"LY\",\"cityPinyin\":\"longyan\",\"city_code\":\"348\",\"city_name\":\"龙岩\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"AQ\",\"cityPinyin\":\"anqing\",\"city_code\":\"177\",\"city_name\":\"安庆\",\"city_name_en\":\"A\"},{\"area_id\":4,\"cityAbbreviation\":\"RZ\",\"cityPinyin\":\"rizhao\",\"city_code\":\"1106\",\"city_name\":\"日照\",\"city_name_en\":\"R\"},{\"area_id\":4,\"cityAbbreviation\":\"ZY\",\"cityPinyin\":\"zunyi\",\"city_code\":\"558\",\"city_name\":\"遵义\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"SM\",\"cityPinyin\":\"sanming\",\"city_code\":\"437\",\"city_name\":\"三明\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"HLBE\",\"cityPinyin\":\"hulunbeier\",\"city_code\":\"4255\",\"city_name\":\"呼伦贝尔\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zhangzhi\",\"city_code\":\"137\",\"city_name\":\"长治\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"XT\",\"cityPinyin\":\"xiangtan\",\"city_code\":\"598\",\"city_name\":\"湘潭\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"DY\",\"cityPinyin\":\"deyang\",\"city_code\":\"237\",\"city_name\":\"德阳\",\"city_name_en\":\"D\"},{\"area_id\":4,\"cityAbbreviation\":\"NC\",\"cityPinyin\":\"nanchong\",\"city_code\":\"377\",\"city_name\":\"南充\",\"city_name_en\":\"N\"},{\"area_id\":4,\"cityAbbreviation\":\"LS\",\"cityPinyin\":\"leshan\",\"city_code\":\"345\",\"city_name\":\"乐山\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"DZ\",\"cityPinyin\":\"dazhou\",\"city_code\":\"1233\",\"city_name\":\"达州\",\"city_name_en\":\"D\"},{\"area_id\":4,\"cityAbbreviation\":\"PJ\",\"cityPinyin\":\"panjin\",\"city_code\":\"387\",\"city_name\":\"盘锦\",\"city_name_en\":\"P\"},{\"area_id\":4,\"cityAbbreviation\":\"YA\",\"cityPinyin\":\"yanan\",\"city_code\":\"110\",\"city_name\":\"延安\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"SR\",\"cityPinyin\":\"shangrao\",\"city_code\":\"411\",\"city_name\":\"上饶\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"JZ\",\"cityPinyin\":\"jinzhou\",\"city_code\":\"327\",\"city_name\":\"锦州\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yichun\",\"city_code\":\"518\",\"city_name\":\"宜春\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"YB\",\"cityPinyin\":\"yibin\",\"city_code\":\"514\",\"city_name\":\"宜宾\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"ZJK\",\"cityPinyin\":\"zhangjiakou\",\"city_code\":\"550\",\"city_name\":\"张家口\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"MAS\",\"cityPinyin\":\"maanshan\",\"city_code\":\"1024\",\"city_name\":\"马鞍山\",\"city_name_en\":\"M\"},{\"area_id\":4,\"cityAbbreviation\":\"LL\",\"cityPinyin\":\"lu:liang\",\"city_code\":\"7631\",\"city_name\":\"吕梁\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"FS\",\"cityPinyin\":\"fushun\",\"city_code\":\"252\",\"city_name\":\"抚顺\",\"city_name_en\":\"F\"},{\"area_id\":4,\"cityAbbreviation\":\"LF\",\"cityPinyin\":\"linfen\",\"city_code\":\"139\",\"city_name\":\"临汾\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"WN\",\"cityPinyin\":\"weinan\",\"city_code\":\"1030\",\"city_name\":\"渭南\",\"city_name_en\":\"W\"},{\"area_id\":4,\"cityAbbreviation\":\"KF\",\"cityPinyin\":\"kaifeng\",\"city_code\":\"331\",\"city_name\":\"开封\",\"city_name_en\":\"K\"},{\"area_id\":4,\"cityAbbreviation\":\"PT\",\"cityPinyin\":\"putian\",\"city_code\":\"667\",\"city_name\":\"莆田\",\"city_name_en\":\"P\"},{\"area_id\":4,\"cityAbbreviation\":\"JZ\",\"cityPinyin\":\"jingzhou\",\"city_code\":\"328\",\"city_name\":\"荆州\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"HG\",\"cityPinyin\":\"huanggang\",\"city_code\":\"3885\",\"city_name\":\"黄冈\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"SP\",\"cityPinyin\":\"siping\",\"city_code\":\"440\",\"city_name\":\"四平\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"CD\",\"cityPinyin\":\"chengde\",\"city_code\":\"562\",\"city_name\":\"承德\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"QQHE\",\"cityPinyin\":\"qiqihaer\",\"city_code\":\"149\",\"city_name\":\"齐齐哈尔\",\"city_name_en\":\"Q\"},{\"area_id\":4,\"cityAbbreviation\":\"SMX\",\"cityPinyin\":\"sanmenxia\",\"city_code\":\"436\",\"city_name\":\"三门峡\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"QHD\",\"cityPinyin\":\"qinhuangdao\",\"city_code\":\"147\",\"city_name\":\"秦皇岛\",\"city_name_en\":\"Q\"},{\"area_id\":4,\"cityAbbreviation\":\"BX\",\"cityPinyin\":\"benxi\",\"city_code\":\"1155\",\"city_name\":\"本溪\",\"city_name_en\":\"B\"},{\"area_id\":4,\"cityAbbreviation\":\"YL\",\"cityPinyin\":\"yulin\",\"city_code\":\"1113\",\"city_name\":\"玉林\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"XG\",\"cityPinyin\":\"xiaogan\",\"city_code\":\"1490\",\"city_name\":\"孝感\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"MDJ\",\"cityPinyin\":\"mudanjiang\",\"city_code\":\"150\",\"city_name\":\"牡丹江\",\"city_name_en\":\"M\"},{\"area_id\":4,\"cityAbbreviation\":\"JM\",\"cityPinyin\":\"jingmen\",\"city_code\":\"1121\",\"city_name\":\"荆门\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"ND\",\"cityPinyin\":\"ningde\",\"city_code\":\"378\",\"city_name\":\"宁德\",\"city_name_en\":\"N\"},{\"area_id\":4,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yuncheng\",\"city_code\":\"140\",\"city_name\":\"运城\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"SH\",\"cityPinyin\":\"suihua\",\"city_code\":\"1128\",\"city_name\":\"绥化\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"YZ\",\"cityPinyin\":\"yongzhou\",\"city_code\":\"970\",\"city_name\":\"永州\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"HH\",\"cityPinyin\":\"huaihua\",\"city_code\":\"282\",\"city_name\":\"怀化\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"HS\",\"cityPinyin\":\"huangshi\",\"city_code\":\"292\",\"city_name\":\"黄石\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"LZ\",\"cityPinyin\":\"luzhou\",\"city_code\":\"355\",\"city_name\":\"泸州\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"QY\",\"cityPinyin\":\"qingyuan\",\"city_code\":\"1422\",\"city_name\":\"清远\",\"city_name_en\":\"Q\"},{\"area_id\":4,\"cityAbbreviation\":\"SY\",\"cityPinyin\":\"shaoyang\",\"city_code\":\"1111\",\"city_name\":\"邵阳\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"HS\",\"cityPinyin\":\"hengshui\",\"city_code\":\"290\",\"city_name\":\"衡水\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"YY\",\"cityPinyin\":\"yiyang\",\"city_code\":\"1125\",\"city_name\":\"益阳\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"DD\",\"cityPinyin\":\"dandong\",\"city_code\":\"221\",\"city_name\":\"丹东\",\"city_name_en\":\"D\"},{\"area_id\":4,\"cityAbbreviation\":\"TL\",\"cityPinyin\":\"tieling\",\"city_code\":\"1048\",\"city_name\":\"铁岭\",\"city_name_en\":\"T\"},{\"area_id\":4,\"cityAbbreviation\":\"JC\",\"cityPinyin\":\"jincheng\",\"city_code\":\"1092\",\"city_name\":\"晋城\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"SZ\",\"cityPinyin\":\"shuozhou\",\"city_code\":\"1317\",\"city_name\":\"朔州\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"JA\",\"cityPinyin\":\"jian\",\"city_code\":\"933\",\"city_name\":\"吉安\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"LD\",\"cityPinyin\":\"loudi\",\"city_code\":\"918\",\"city_name\":\"娄底\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"YX\",\"cityPinyin\":\"yuxi\",\"city_code\":\"186\",\"city_name\":\"玉溪\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"LY\",\"cityPinyin\":\"liaoyang\",\"city_code\":\"351\",\"city_name\":\"辽阳\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"NP\",\"cityPinyin\":\"nanping\",\"city_code\":\"606\",\"city_name\":\"南平\",\"city_name_en\":\"N\"},{\"area_id\":4,\"cityAbbreviation\":\"PY\",\"cityPinyin\":\"puyang\",\"city_code\":\"1232\",\"city_name\":\"濮阳\",\"city_name_en\":\"P\"},{\"area_id\":4,\"cityAbbreviation\":\"JZ\",\"cityPinyin\":\"jinzhong\",\"city_code\":\"1453\",\"city_name\":\"晋中\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"ZY\",\"cityPinyin\":\"ziyang\",\"city_code\":\"1560\",\"city_name\":\"资阳\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"DJY\",\"cityPinyin\":\"doujiangyan\",\"city_code\":\"94\",\"city_name\":\"都江堰\",\"city_name_en\":\"D\"},{\"area_id\":4,\"cityAbbreviation\":\"PZH\",\"cityPinyin\":\"panzhihua\",\"city_code\":\"1097\",\"city_name\":\"攀枝花\",\"city_name_en\":\"P\"},{\"area_id\":4,\"cityAbbreviation\":\"QZ\",\"cityPinyin\":\"quzhou\",\"city_code\":\"407\",\"city_name\":\"衢州\",\"city_name_en\":\"Q\"},{\"area_id\":4,\"cityAbbreviation\":\"NJ\",\"cityPinyin\":\"neijiang\",\"city_code\":\"1597\",\"city_name\":\"内江\",\"city_name_en\":\"N\"},{\"area_id\":4,\"cityAbbreviation\":\"CZ\",\"cityPinyin\":\"chuzhou\",\"city_code\":\"214\",\"city_name\":\"滁州\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"FY\",\"cityPinyin\":\"fuyang\",\"city_code\":\"257\",\"city_name\":\"阜阳\",\"city_name_en\":\"F\"},{\"area_id\":4,\"cityAbbreviation\":\"SY\",\"cityPinyin\":\"shiyan\",\"city_code\":\"452\",\"city_name\":\"十堰\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"DT\",\"cityPinyin\":\"datong\",\"city_code\":\"136\",\"city_name\":\"大同\",\"city_name_en\":\"D\"},{\"area_id\":4,\"cityAbbreviation\":\"CY\",\"cityPinyin\":\"chaoyang\",\"city_code\":\"211\",\"city_name\":\"朝阳\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"LA\",\"cityPinyin\":\"liuan\",\"city_code\":\"1705\",\"city_name\":\"六安\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"SZ\",\"cityPinyin\":\"suzhou\",\"city_code\":\"521\",\"city_name\":\"宿州\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"TH\",\"cityPinyin\":\"tonghua\",\"city_code\":\"456\",\"city_name\":\"通化\",\"city_name_en\":\"T\"},{\"area_id\":4,\"cityAbbreviation\":\"BB\",\"cityPinyin\":\"bangbu\",\"city_code\":\"182\",\"city_name\":\"蚌埠\",\"city_name_en\":\"B\"},{\"area_id\":4,\"cityAbbreviation\":\"SG\",\"cityPinyin\":\"shaoguan\",\"city_code\":\"422\",\"city_name\":\"韶关\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"LS\",\"cityPinyin\":\"lishui\",\"city_code\":\"346\",\"city_name\":\"丽水\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"ZG\",\"cityPinyin\":\"zigong\",\"city_code\":\"544\",\"city_name\":\"自贡\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"YJ\",\"cityPinyin\":\"yangjiang\",\"city_code\":\"692\",\"city_name\":\"阳江\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"BJ\",\"cityPinyin\":\"bijie\",\"city_code\":\"22031\",\"city_name\":\"毕节\",\"city_name_en\":\"B\"},{\"area_id\":5,\"cityAbbreviation\":\"XG\",\"cityPinyin\":\"xianggang\",\"city_code\":\"58\",\"city_name\":\"香港\",\"city_name_en\":\"X\"},{\"area_id\":5,\"cityAbbreviation\":\"AM\",\"cityPinyin\":\"aomen\",\"city_code\":\"59\",\"city_name\":\"澳门\",\"city_name_en\":\"A\"},{\"area_id\":5,\"cityAbbreviation\":\"TW\",\"cityPinyin\":\"taiwan\",\"city_code\":\"53\",\"city_name\":\"台湾\",\"city_name_en\":\"T\"}]}";
        String[] a1 = zxs.split("、");
        String[] a2 = shcs.split("、");
        String[] a3 = jhdls.split("、");
        //把json序列化指定的对象
        CityJsonDataVo cityJsonDataVo = JsonUtils.parse(data, CityJsonDataVo.class);
        List<CityJson> citysList = cityJsonDataVo.getCitys();
        List<CityJson> newCitysList = new ArrayList<>();
        for (CityJson cityJson : citysList) {
            for (String a : a1) {
                if (cityJson.getCity_name().equals(a)) {
                    cityJson.setArea_id(1);
                    newCitysList.add(cityJson);
                }
            }
            for (String a : a2) {
                if (cityJson.getCity_name().equals(a)) {
                    cityJson.setArea_id(2);
                    newCitysList.add(cityJson);
                }
            }
            for (String a : a3) {
                if (cityJson.getCity_name().equals(a)) {
                    cityJson.setArea_id(3);
                    newCitysList.add(cityJson);
                }
            }
        }
        System.out.println(JsonUtils.toJsonString(newCitysList));
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public List<AreaVo> initAreaData(String orgId) {
        //初始化地区数据
//        String areaData = "{\"areas\":[{\"id\":1,\"area_name\":\"一线城市\",\"areaType\":\"0\"},{\"id\":2,\"area_name\":\"二线城市\",\"areaType\":\"0\"},{\"id\":3,\"area_name\":\"三线城市\",\"areaType\":\"0\"},{\"id\":4,\"area_name\":\"四线城市\",\"areaType\":\"0\"},{\"id\":5,\"area_name\":\"港澳台\",\"areaType\":\"0\"},{\"id\":6,\"area_name\":\"其他城市\",\"areaType\":\"1\"}]}";
        String areaData = "{\"areas\":[{\"id\":1,\"area_name\":\"直辖市\",\"areaType\":\"0\"},{\"id\":2,\"area_name\":\"省会城市\",\"areaType\":\"0\"},{\"id\":3,\"area_name\":\"计划单列市\",\"areaType\":\"0\"},{\"id\":4,\"area_name\":\"国内其它城市\",\"areaType\":\"1\"}]}";
        //把json序列化指定的对象
        AreaJsonDataVo areaJsonDataVo = JsonUtils.parse(areaData, AreaJsonDataVo.class);
        List<AreaJson> areasList = areaJsonDataVo.getAreas();
        //初始化城市数据
        //String cityData = "{\"citys\":[{\"area_id\":1,\"cityAbbreviation\":\"BJ\",\"cityPinyin\":\"beijing\",\"city_code\":\"1\",\"city_name\":\"北京\",\"city_name_en\":\"B\"},{\"area_id\":1,\"cityAbbreviation\":\"SH\",\"cityPinyin\":\"shanghai\",\"city_code\":\"2\",\"city_name\":\"上海\",\"city_name_en\":\"S\"},{\"area_id\":1,\"cityAbbreviation\":\"GZ\",\"cityPinyin\":\"guangzhou\",\"city_code\":\"32\",\"city_name\":\"广州\",\"city_name_en\":\"G\"},{\"area_id\":1,\"cityAbbreviation\":\"SZ\",\"cityPinyin\":\"shenzhen\",\"city_code\":\"30\",\"city_name\":\"深圳\",\"city_name_en\":\"S\"},{\"area_id\":1,\"cityAbbreviation\":\"TJ\",\"cityPinyin\":\"tianjin\",\"city_code\":\"3\",\"city_name\":\"天津\",\"city_name_en\":\"T\"},{\"area_id\":2,\"cityAbbreviation\":\"HZ\",\"cityPinyin\":\"hangzhou\",\"city_code\":\"17\",\"city_name\":\"杭州\",\"city_name_en\":\"H\"},{\"area_id\":2,\"cityAbbreviation\":\"NJ\",\"cityPinyin\":\"nanjing\",\"city_code\":\"12\",\"city_name\":\"南京\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"JN\",\"cityPinyin\":\"jinan\",\"city_code\":\"144\",\"city_name\":\"济南\",\"city_name_en\":\"J\"},{\"area_id\":2,\"cityAbbreviation\":\"CQ\",\"cityPinyin\":\"CQ\",\"city_code\":\"4\",\"city_name\":\"重庆\",\"city_name_en\":\"C\"},{\"area_id\":2,\"cityAbbreviation\":\"QD\",\"cityPinyin\":\"qingdao\",\"city_code\":\"7\",\"city_name\":\"青岛\",\"city_name_en\":\"Q\"},{\"area_id\":2,\"cityAbbreviation\":\"DL\",\"cityPinyin\":\"dalian\",\"city_code\":\"6\",\"city_name\":\"大连\",\"city_name_en\":\"D\"},{\"area_id\":2,\"cityAbbreviation\":\"NB\",\"cityPinyin\":\"ningbo\",\"city_code\":\"375\",\"city_name\":\"宁波\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"SM\",\"cityPinyin\":\"shamen\",\"city_code\":\"26\",\"city_name\":\"厦门\",\"city_name_en\":\"X\"},{\"area_id\":2,\"cityAbbreviation\":\"CD\",\"cityPinyin\":\"chengdou\",\"city_code\":\"28\",\"city_name\":\"成都\",\"city_name_en\":\"C\"},{\"area_id\":2,\"cityAbbreviation\":\"WH\",\"cityPinyin\":\"wuhan\",\"city_code\":\"477\",\"city_name\":\"武汉\",\"city_name_en\":\"W\"},{\"area_id\":2,\"cityAbbreviation\":\"HEB\",\"cityPinyin\":\"haerbin\",\"city_code\":\"5\",\"city_name\":\"哈尔滨\",\"city_name_en\":\"H\"},{\"area_id\":2,\"cityAbbreviation\":\"SY\",\"cityPinyin\":\"shenyang\",\"city_code\":\"451\",\"city_name\":\"沈阳\",\"city_name_en\":\"S\"},{\"area_id\":2,\"cityAbbreviation\":\"XA\",\"cityPinyin\":\"xian\",\"city_code\":\"10\",\"city_name\":\"西安\",\"city_name_en\":\"X\"},{\"area_id\":2,\"cityAbbreviation\":\"ZC\",\"cityPinyin\":\"zhangchun\",\"city_code\":\"158\",\"city_name\":\"长春\",\"city_name_en\":\"C\"},{\"area_id\":2,\"cityAbbreviation\":\"ZS\",\"cityPinyin\":\"zhangsha\",\"city_code\":\"206\",\"city_name\":\"长沙\",\"city_name_en\":\"C\"},{\"area_id\":2,\"cityAbbreviation\":\"FZ\",\"cityPinyin\":\"fuzhou\",\"city_code\":\"258\",\"city_name\":\"福州\",\"city_name_en\":\"F\"},{\"area_id\":2,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zhengzhou\",\"city_code\":\"559\",\"city_name\":\"郑州\",\"city_name_en\":\"Z\"},{\"area_id\":2,\"cityAbbreviation\":\"SJZ\",\"cityPinyin\":\"shijiazhuang\",\"city_code\":\"428\",\"city_name\":\"石家庄\",\"city_name_en\":\"S\"},{\"area_id\":2,\"cityAbbreviation\":\"SZ\",\"cityPinyin\":\"suzhou\",\"city_code\":\"14\",\"city_name\":\"苏州\",\"city_name_en\":\"S\"},{\"area_id\":2,\"cityAbbreviation\":\"FS\",\"cityPinyin\":\"foshan\",\"city_code\":\"251\",\"city_name\":\"佛山\",\"city_name_en\":\"F\"},{\"area_id\":2,\"cityAbbreviation\":\"DG\",\"cityPinyin\":\"dongguan\",\"city_code\":\"223\",\"city_name\":\"东莞\",\"city_name_en\":\"D\"},{\"area_id\":2,\"cityAbbreviation\":\"WX\",\"cityPinyin\":\"wuxi\",\"city_code\":\"13\",\"city_name\":\"无锡\",\"city_name_en\":\"W\"},{\"area_id\":2,\"cityAbbreviation\":\"YT\",\"cityPinyin\":\"yantai\",\"city_code\":\"533\",\"city_name\":\"烟台\",\"city_name_en\":\"Y\"},{\"area_id\":2,\"cityAbbreviation\":\"TY\",\"cityPinyin\":\"taiyuan\",\"city_code\":\"105\",\"city_name\":\"太原\",\"city_name_en\":\"T\"},{\"area_id\":2,\"cityAbbreviation\":\"HF\",\"cityPinyin\":\"hefei\",\"city_code\":\"278\",\"city_name\":\"合肥\",\"city_name_en\":\"H\"},{\"area_id\":2,\"cityAbbreviation\":\"NC\",\"cityPinyin\":\"nanchang\",\"city_code\":\"376\",\"city_name\":\"南昌\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"NN\",\"cityPinyin\":\"nanning\",\"city_code\":\"380\",\"city_name\":\"南宁\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"KM\",\"cityPinyin\":\"kunming\",\"city_code\":\"34\",\"city_name\":\"昆明\",\"city_name_en\":\"K\"},{\"area_id\":2,\"cityAbbreviation\":\"WZ\",\"cityPinyin\":\"wenzhou\",\"city_code\":\"491\",\"city_name\":\"温州\",\"city_name_en\":\"W\"},{\"area_id\":2,\"cityAbbreviation\":\"ZB\",\"cityPinyin\":\"zibo\",\"city_code\":\"542\",\"city_name\":\"淄博\",\"city_name_en\":\"Z\"},{\"area_id\":2,\"cityAbbreviation\":\"TS\",\"cityPinyin\":\"tangshan\",\"city_code\":\"468\",\"city_name\":\"唐山\",\"city_name_en\":\"T\"},{\"area_id\":3,\"cityAbbreviation\":\"WLMQ\",\"cityPinyin\":\"wulumuqi\",\"city_code\":\"39\",\"city_name\":\"乌鲁木齐\",\"city_name_en\":\"W\"},{\"area_id\":3,\"cityAbbreviation\":\"GY\",\"cityPinyin\":\"guiyang\",\"city_code\":\"38\",\"city_name\":\"贵阳\",\"city_name_en\":\"G\"},{\"area_id\":3,\"cityAbbreviation\":\"HK\",\"cityPinyin\":\"haikou\",\"city_code\":\"42\",\"city_name\":\"海口\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"LZ\",\"cityPinyin\":\"lanzhou\",\"city_code\":\"100\",\"city_name\":\"兰州\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yinchuan\",\"city_code\":\"99\",\"city_name\":\"银川\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"XN\",\"cityPinyin\":\"xining\",\"city_code\":\"124\",\"city_name\":\"西宁\",\"city_name_en\":\"X\"},{\"area_id\":3,\"cityAbbreviation\":\"HHHT\",\"cityPinyin\":\"huhehaote\",\"city_code\":\"103\",\"city_name\":\"呼和浩特\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"QZ\",\"cityPinyin\":\"quanzhou\",\"city_code\":\"406\",\"city_name\":\"泉州\",\"city_name_en\":\"Q\"},{\"area_id\":3,\"cityAbbreviation\":\"BT\",\"cityPinyin\":\"baotou\",\"city_code\":\"141\",\"city_name\":\"包头\",\"city_name_en\":\"B\"},{\"area_id\":3,\"cityAbbreviation\":\"NT\",\"cityPinyin\":\"nantong\",\"city_code\":\"82\",\"city_name\":\"南通\",\"city_name_en\":\"N\"},{\"area_id\":3,\"cityAbbreviation\":\"DQ\",\"cityPinyin\":\"daqing\",\"city_code\":\"231\",\"city_name\":\"大庆\",\"city_name_en\":\"D\"},{\"area_id\":3,\"cityAbbreviation\":\"XZ\",\"cityPinyin\":\"xuzhou\",\"city_code\":\"512\",\"city_name\":\"徐州\",\"city_name_en\":\"X\"},{\"area_id\":3,\"cityAbbreviation\":\"WF\",\"cityPinyin\":\"weifang\",\"city_code\":\"475\",\"city_name\":\"潍坊\",\"city_name_en\":\"W\"},{\"area_id\":3,\"cityAbbreviation\":\"CZ\",\"cityPinyin\":\"changzhou\",\"city_code\":\"213\",\"city_name\":\"常州\",\"city_name_en\":\"C\"},{\"area_id\":3,\"cityAbbreviation\":\"EEDS\",\"cityPinyin\":\"eerduosi\",\"city_code\":\"3976\",\"city_name\":\"鄂尔多斯\",\"city_name_en\":\"E\"},{\"area_id\":3,\"cityAbbreviation\":\"SX\",\"cityPinyin\":\"shaoxing\",\"city_code\":\"22\",\"city_name\":\"绍兴\",\"city_name_en\":\"S\"},{\"area_id\":3,\"cityAbbreviation\":\"JN\",\"cityPinyin\":\"jining\",\"city_code\":\"318\",\"city_name\":\"济宁\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yancheng\",\"city_code\":\"1200\",\"city_name\":\"盐城\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"HD\",\"cityPinyin\":\"handan\",\"city_code\":\"275\",\"city_name\":\"邯郸\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"LY\",\"cityPinyin\":\"linyi\",\"city_code\":\"569\",\"city_name\":\"临沂\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"LY\",\"cityPinyin\":\"luoyang\",\"city_code\":\"350\",\"city_name\":\"洛阳\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"DY\",\"cityPinyin\":\"dongying\",\"city_code\":\"236\",\"city_name\":\"东营\",\"city_name_en\":\"D\"},{\"area_id\":3,\"cityAbbreviation\":\"YZ\",\"cityPinyin\":\"yangzhou\",\"city_code\":\"15\",\"city_name\":\"扬州\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"TZ\",\"cityPinyin\":\"taizhou\",\"city_code\":\"578\",\"city_name\":\"台州\",\"city_name_en\":\"T\"},{\"area_id\":3,\"cityAbbreviation\":\"JX\",\"cityPinyin\":\"jiaxing\",\"city_code\":\"571\",\"city_name\":\"嘉兴\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"CZ\",\"cityPinyin\":\"cangzhou\",\"city_code\":\"216\",\"city_name\":\"沧州\",\"city_name_en\":\"C\"},{\"area_id\":3,\"cityAbbreviation\":\"YL\",\"cityPinyin\":\"yulin\",\"city_code\":\"527\",\"city_name\":\"榆林\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"TZ\",\"cityPinyin\":\"taizhou\",\"city_code\":\"579\",\"city_name\":\"泰州\",\"city_name_en\":\"T\"},{\"area_id\":3,\"cityAbbreviation\":\"ZJ\",\"cityPinyin\":\"zhenjiang\",\"city_code\":\"16\",\"city_name\":\"镇江\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"KS\",\"cityPinyin\":\"kunshan\",\"city_code\":\"83\",\"city_name\":\"昆山\",\"city_name_en\":\"K\"},{\"area_id\":3,\"cityAbbreviation\":\"JY\",\"cityPinyin\":\"jiangyin\",\"city_code\":\"325\",\"city_name\":\"江阴\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"ZJG\",\"cityPinyin\":\"zhangjiagang\",\"city_code\":\"621\",\"city_name\":\"张家港\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"YW\",\"cityPinyin\":\"yiwu\",\"city_code\":\"536\",\"city_name\":\"义乌\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"JH\",\"cityPinyin\":\"jinhua\",\"city_code\":\"308\",\"city_name\":\"金华\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"BD\",\"cityPinyin\":\"baoding\",\"city_code\":\"185\",\"city_name\":\"保定\",\"city_name_en\":\"B\"},{\"area_id\":3,\"cityAbbreviation\":\"JL\",\"cityPinyin\":\"jilin\",\"city_code\":\"159\",\"city_name\":\"吉林\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"AS\",\"cityPinyin\":\"anshan\",\"city_code\":\"178\",\"city_name\":\"鞍山\",\"city_name_en\":\"A\"},{\"area_id\":3,\"cityAbbreviation\":\"TA\",\"cityPinyin\":\"taian\",\"city_code\":\"454\",\"city_name\":\"泰安\",\"city_name_en\":\"T\"},{\"area_id\":3,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yichang\",\"city_code\":\"515\",\"city_name\":\"宜昌\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"XY\",\"cityPinyin\":\"xiangyang\",\"city_code\":\"496\",\"city_name\":\"襄阳\",\"city_name_en\":\"X\"},{\"area_id\":3,\"cityAbbreviation\":\"ZS\",\"cityPinyin\":\"zhongshan\",\"city_code\":\"553\",\"city_name\":\"中山\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"HZ\",\"cityPinyin\":\"huizhou\",\"city_code\":\"299\",\"city_name\":\"惠州\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"NY\",\"cityPinyin\":\"nanyang\",\"city_code\":\"385\",\"city_name\":\"南阳\",\"city_name_en\":\"N\"},{\"area_id\":3,\"cityAbbreviation\":\"WH\",\"cityPinyin\":\"weihai\",\"city_code\":\"479\",\"city_name\":\"威海\",\"city_name_en\":\"W\"},{\"area_id\":3,\"cityAbbreviation\":\"DZ\",\"cityPinyin\":\"dezhou\",\"city_code\":\"1370\",\"city_name\":\"德州\",\"city_name_en\":\"D\"},{\"area_id\":3,\"cityAbbreviation\":\"YY\",\"cityPinyin\":\"yueyang\",\"city_code\":\"539\",\"city_name\":\"岳阳\",\"city_name_en\":\"Y\"},{\"area_id\":3,\"cityAbbreviation\":\"LC\",\"cityPinyin\":\"liaocheng\",\"city_code\":\"1071\",\"city_name\":\"聊城\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"CD\",\"cityPinyin\":\"changde\",\"city_code\":\"201\",\"city_name\":\"常德\",\"city_name_en\":\"C\"},{\"area_id\":3,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zhangzhou\",\"city_code\":\"560\",\"city_name\":\"漳州\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"BZ\",\"cityPinyin\":\"binzhou\",\"city_code\":\"1820\",\"city_name\":\"滨州\",\"city_name_en\":\"B\"},{\"area_id\":3,\"cityAbbreviation\":\"MM\",\"cityPinyin\":\"maoming\",\"city_code\":\"1105\",\"city_name\":\"茂名\",\"city_name_en\":\"M\"},{\"area_id\":3,\"cityAbbreviation\":\"HA\",\"cityPinyin\":\"huaian\",\"city_code\":\"577\",\"city_name\":\"淮安\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"JM\",\"cityPinyin\":\"jiangmen\",\"city_code\":\"316\",\"city_name\":\"江门\",\"city_name_en\":\"J\"},{\"area_id\":3,\"cityAbbreviation\":\"WH\",\"cityPinyin\":\"wuhu\",\"city_code\":\"478\",\"city_name\":\"芜湖\",\"city_name_en\":\"W\"},{\"area_id\":3,\"cityAbbreviation\":\"ZJ\",\"cityPinyin\":\"zhanjiang\",\"city_code\":\"547\",\"city_name\":\"湛江\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"LF\",\"cityPinyin\":\"langfang\",\"city_code\":\"340\",\"city_name\":\"廊坊\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"HZ\",\"cityPinyin\":\"heze\",\"city_code\":\"1074\",\"city_name\":\"菏泽\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"LZ\",\"cityPinyin\":\"liuzhou\",\"city_code\":\"112\",\"city_name\":\"柳州\",\"city_name_en\":\"L\"},{\"area_id\":3,\"cityAbbreviation\":\"BJ\",\"cityPinyin\":\"baoji\",\"city_code\":\"354\",\"city_name\":\"宝鸡\",\"city_name_en\":\"B\"},{\"area_id\":3,\"cityAbbreviation\":\"ZH\",\"cityPinyin\":\"zhuhai\",\"city_code\":\"31\",\"city_name\":\"珠海\",\"city_name_en\":\"Z\"},{\"area_id\":3,\"cityAbbreviation\":\"MY\",\"cityPinyin\":\"mianyang\",\"city_code\":\"370\",\"city_name\":\"绵阳\",\"city_name_en\":\"M\"},{\"area_id\":4,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zhuzhou\",\"city_code\":\"601\",\"city_name\":\"株洲\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zaozhuang\",\"city_code\":\"614\",\"city_name\":\"枣庄\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"XC\",\"cityPinyin\":\"xuchang\",\"city_code\":\"1094\",\"city_name\":\"许昌\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"TL\",\"cityPinyin\":\"tongliao\",\"city_code\":\"458\",\"city_name\":\"通辽\",\"city_name_en\":\"T\"},{\"area_id\":4,\"cityAbbreviation\":\"HZ\",\"cityPinyin\":\"huzhou\",\"city_code\":\"86\",\"city_name\":\"湖州\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"XX\",\"cityPinyin\":\"xinxiang\",\"city_code\":\"507\",\"city_name\":\"新乡\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"XY\",\"cityPinyin\":\"xianyang\",\"city_code\":\"111\",\"city_name\":\"咸阳\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"SY\",\"cityPinyin\":\"songyuan\",\"city_code\":\"1303\",\"city_name\":\"松原\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"LYG\",\"cityPinyin\":\"lianyungang\",\"city_code\":\"353\",\"city_name\":\"连云港\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"AY\",\"cityPinyin\":\"anyang\",\"city_code\":\"181\",\"city_name\":\"安阳\",\"city_name_en\":\"A\"},{\"area_id\":4,\"cityAbbreviation\":\"ZK\",\"cityPinyin\":\"zhoukou\",\"city_code\":\"3221\",\"city_name\":\"周口\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"JZ\",\"cityPinyin\":\"jiaozuo\",\"city_code\":\"1093\",\"city_name\":\"焦作\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"CF\",\"cityPinyin\":\"chifeng\",\"city_code\":\"202\",\"city_name\":\"赤峰\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"XT\",\"cityPinyin\":\"xingtai\",\"city_code\":\"947\",\"city_name\":\"邢台\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"CZ\",\"cityPinyin\":\"chenzhou\",\"city_code\":\"612\",\"city_name\":\"郴州\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"SQ\",\"cityPinyin\":\"suqian\",\"city_code\":\"1472\",\"city_name\":\"宿迁\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"GZ\",\"cityPinyin\":\"ganzhou\",\"city_code\":\"268\",\"city_name\":\"赣州\",\"city_name_en\":\"G\"},{\"area_id\":4,\"cityAbbreviation\":\"PDS\",\"cityPinyin\":\"pingdingshan\",\"city_code\":\"3222\",\"city_name\":\"平顶山\",\"city_name_en\":\"P\"},{\"area_id\":4,\"cityAbbreviation\":\"GL\",\"cityPinyin\":\"guilin\",\"city_code\":\"33\",\"city_name\":\"桂林\",\"city_name_en\":\"G\"},{\"area_id\":4,\"cityAbbreviation\":\"ZQ\",\"cityPinyin\":\"zhaoqing\",\"city_code\":\"552\",\"city_name\":\"肇庆\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"QJ\",\"cityPinyin\":\"qujing\",\"city_code\":\"985\",\"city_name\":\"曲靖\",\"city_name_en\":\"Q\"},{\"area_id\":4,\"cityAbbreviation\":\"JJ\",\"cityPinyin\":\"jiujiang\",\"city_code\":\"24\",\"city_name\":\"九江\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"SQ\",\"cityPinyin\":\"shangqiu\",\"city_code\":\"441\",\"city_name\":\"商丘\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"ST\",\"cityPinyin\":\"shantou\",\"city_code\":\"447\",\"city_name\":\"汕头\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"XY\",\"cityPinyin\":\"xinyang\",\"city_code\":\"510\",\"city_name\":\"信阳\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"ZMD\",\"cityPinyin\":\"zhumadian\",\"city_code\":\"551\",\"city_name\":\"驻马店\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"YK\",\"cityPinyin\":\"yingkou\",\"city_code\":\"1300\",\"city_name\":\"营口\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"JY\",\"cityPinyin\":\"jieyang\",\"city_code\":\"956\",\"city_name\":\"揭阳\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"LY\",\"cityPinyin\":\"longyan\",\"city_code\":\"348\",\"city_name\":\"龙岩\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"AQ\",\"cityPinyin\":\"anqing\",\"city_code\":\"177\",\"city_name\":\"安庆\",\"city_name_en\":\"A\"},{\"area_id\":4,\"cityAbbreviation\":\"RZ\",\"cityPinyin\":\"rizhao\",\"city_code\":\"1106\",\"city_name\":\"日照\",\"city_name_en\":\"R\"},{\"area_id\":4,\"cityAbbreviation\":\"ZY\",\"cityPinyin\":\"zunyi\",\"city_code\":\"558\",\"city_name\":\"遵义\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"SM\",\"cityPinyin\":\"sanming\",\"city_code\":\"437\",\"city_name\":\"三明\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"HLBE\",\"cityPinyin\":\"hulunbeier\",\"city_code\":\"4255\",\"city_name\":\"呼伦贝尔\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zhangzhi\",\"city_code\":\"137\",\"city_name\":\"长治\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"XT\",\"cityPinyin\":\"xiangtan\",\"city_code\":\"598\",\"city_name\":\"湘潭\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"DY\",\"cityPinyin\":\"deyang\",\"city_code\":\"237\",\"city_name\":\"德阳\",\"city_name_en\":\"D\"},{\"area_id\":4,\"cityAbbreviation\":\"NC\",\"cityPinyin\":\"nanchong\",\"city_code\":\"377\",\"city_name\":\"南充\",\"city_name_en\":\"N\"},{\"area_id\":4,\"cityAbbreviation\":\"LS\",\"cityPinyin\":\"leshan\",\"city_code\":\"345\",\"city_name\":\"乐山\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"DZ\",\"cityPinyin\":\"dazhou\",\"city_code\":\"1233\",\"city_name\":\"达州\",\"city_name_en\":\"D\"},{\"area_id\":4,\"cityAbbreviation\":\"PJ\",\"cityPinyin\":\"panjin\",\"city_code\":\"387\",\"city_name\":\"盘锦\",\"city_name_en\":\"P\"},{\"area_id\":4,\"cityAbbreviation\":\"YA\",\"cityPinyin\":\"yanan\",\"city_code\":\"110\",\"city_name\":\"延安\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"SR\",\"cityPinyin\":\"shangrao\",\"city_code\":\"411\",\"city_name\":\"上饶\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"JZ\",\"cityPinyin\":\"jinzhou\",\"city_code\":\"327\",\"city_name\":\"锦州\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yichun\",\"city_code\":\"518\",\"city_name\":\"宜春\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"YB\",\"cityPinyin\":\"yibin\",\"city_code\":\"514\",\"city_name\":\"宜宾\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"ZJK\",\"cityPinyin\":\"zhangjiakou\",\"city_code\":\"550\",\"city_name\":\"张家口\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"MAS\",\"cityPinyin\":\"maanshan\",\"city_code\":\"1024\",\"city_name\":\"马鞍山\",\"city_name_en\":\"M\"},{\"area_id\":4,\"cityAbbreviation\":\"LL\",\"cityPinyin\":\"lu:liang\",\"city_code\":\"7631\",\"city_name\":\"吕梁\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"FS\",\"cityPinyin\":\"fushun\",\"city_code\":\"252\",\"city_name\":\"抚顺\",\"city_name_en\":\"F\"},{\"area_id\":4,\"cityAbbreviation\":\"LF\",\"cityPinyin\":\"linfen\",\"city_code\":\"139\",\"city_name\":\"临汾\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"WN\",\"cityPinyin\":\"weinan\",\"city_code\":\"1030\",\"city_name\":\"渭南\",\"city_name_en\":\"W\"},{\"area_id\":4,\"cityAbbreviation\":\"KF\",\"cityPinyin\":\"kaifeng\",\"city_code\":\"331\",\"city_name\":\"开封\",\"city_name_en\":\"K\"},{\"area_id\":4,\"cityAbbreviation\":\"PT\",\"cityPinyin\":\"putian\",\"city_code\":\"667\",\"city_name\":\"莆田\",\"city_name_en\":\"P\"},{\"area_id\":4,\"cityAbbreviation\":\"JZ\",\"cityPinyin\":\"jingzhou\",\"city_code\":\"328\",\"city_name\":\"荆州\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"HG\",\"cityPinyin\":\"huanggang\",\"city_code\":\"3885\",\"city_name\":\"黄冈\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"SP\",\"cityPinyin\":\"siping\",\"city_code\":\"440\",\"city_name\":\"四平\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"CD\",\"cityPinyin\":\"chengde\",\"city_code\":\"562\",\"city_name\":\"承德\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"QQHE\",\"cityPinyin\":\"qiqihaer\",\"city_code\":\"149\",\"city_name\":\"齐齐哈尔\",\"city_name_en\":\"Q\"},{\"area_id\":4,\"cityAbbreviation\":\"SMX\",\"cityPinyin\":\"sanmenxia\",\"city_code\":\"436\",\"city_name\":\"三门峡\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"QHD\",\"cityPinyin\":\"qinhuangdao\",\"city_code\":\"147\",\"city_name\":\"秦皇岛\",\"city_name_en\":\"Q\"},{\"area_id\":4,\"cityAbbreviation\":\"BX\",\"cityPinyin\":\"benxi\",\"city_code\":\"1155\",\"city_name\":\"本溪\",\"city_name_en\":\"B\"},{\"area_id\":4,\"cityAbbreviation\":\"YL\",\"cityPinyin\":\"yulin\",\"city_code\":\"1113\",\"city_name\":\"玉林\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"XG\",\"cityPinyin\":\"xiaogan\",\"city_code\":\"1490\",\"city_name\":\"孝感\",\"city_name_en\":\"X\"},{\"area_id\":4,\"cityAbbreviation\":\"MDJ\",\"cityPinyin\":\"mudanjiang\",\"city_code\":\"150\",\"city_name\":\"牡丹江\",\"city_name_en\":\"M\"},{\"area_id\":4,\"cityAbbreviation\":\"JM\",\"cityPinyin\":\"jingmen\",\"city_code\":\"1121\",\"city_name\":\"荆门\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"ND\",\"cityPinyin\":\"ningde\",\"city_code\":\"378\",\"city_name\":\"宁德\",\"city_name_en\":\"N\"},{\"area_id\":4,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yuncheng\",\"city_code\":\"140\",\"city_name\":\"运城\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"SH\",\"cityPinyin\":\"suihua\",\"city_code\":\"1128\",\"city_name\":\"绥化\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"YZ\",\"cityPinyin\":\"yongzhou\",\"city_code\":\"970\",\"city_name\":\"永州\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"HH\",\"cityPinyin\":\"huaihua\",\"city_code\":\"282\",\"city_name\":\"怀化\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"HS\",\"cityPinyin\":\"huangshi\",\"city_code\":\"292\",\"city_name\":\"黄石\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"LZ\",\"cityPinyin\":\"luzhou\",\"city_code\":\"355\",\"city_name\":\"泸州\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"QY\",\"cityPinyin\":\"qingyuan\",\"city_code\":\"1422\",\"city_name\":\"清远\",\"city_name_en\":\"Q\"},{\"area_id\":4,\"cityAbbreviation\":\"SY\",\"cityPinyin\":\"shaoyang\",\"city_code\":\"1111\",\"city_name\":\"邵阳\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"HS\",\"cityPinyin\":\"hengshui\",\"city_code\":\"290\",\"city_name\":\"衡水\",\"city_name_en\":\"H\"},{\"area_id\":4,\"cityAbbreviation\":\"YY\",\"cityPinyin\":\"yiyang\",\"city_code\":\"1125\",\"city_name\":\"益阳\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"DD\",\"cityPinyin\":\"dandong\",\"city_code\":\"221\",\"city_name\":\"丹东\",\"city_name_en\":\"D\"},{\"area_id\":4,\"cityAbbreviation\":\"TL\",\"cityPinyin\":\"tieling\",\"city_code\":\"1048\",\"city_name\":\"铁岭\",\"city_name_en\":\"T\"},{\"area_id\":4,\"cityAbbreviation\":\"JC\",\"cityPinyin\":\"jincheng\",\"city_code\":\"1092\",\"city_name\":\"晋城\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"SZ\",\"cityPinyin\":\"shuozhou\",\"city_code\":\"1317\",\"city_name\":\"朔州\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"JA\",\"cityPinyin\":\"jian\",\"city_code\":\"933\",\"city_name\":\"吉安\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"LD\",\"cityPinyin\":\"loudi\",\"city_code\":\"918\",\"city_name\":\"娄底\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"YX\",\"cityPinyin\":\"yuxi\",\"city_code\":\"186\",\"city_name\":\"玉溪\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"LY\",\"cityPinyin\":\"liaoyang\",\"city_code\":\"351\",\"city_name\":\"辽阳\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"NP\",\"cityPinyin\":\"nanping\",\"city_code\":\"606\",\"city_name\":\"南平\",\"city_name_en\":\"N\"},{\"area_id\":4,\"cityAbbreviation\":\"PY\",\"cityPinyin\":\"puyang\",\"city_code\":\"1232\",\"city_name\":\"濮阳\",\"city_name_en\":\"P\"},{\"area_id\":4,\"cityAbbreviation\":\"JZ\",\"cityPinyin\":\"jinzhong\",\"city_code\":\"1453\",\"city_name\":\"晋中\",\"city_name_en\":\"J\"},{\"area_id\":4,\"cityAbbreviation\":\"ZY\",\"cityPinyin\":\"ziyang\",\"city_code\":\"1560\",\"city_name\":\"资阳\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"DJY\",\"cityPinyin\":\"doujiangyan\",\"city_code\":\"94\",\"city_name\":\"都江堰\",\"city_name_en\":\"D\"},{\"area_id\":4,\"cityAbbreviation\":\"PZH\",\"cityPinyin\":\"panzhihua\",\"city_code\":\"1097\",\"city_name\":\"攀枝花\",\"city_name_en\":\"P\"},{\"area_id\":4,\"cityAbbreviation\":\"QZ\",\"cityPinyin\":\"quzhou\",\"city_code\":\"407\",\"city_name\":\"衢州\",\"city_name_en\":\"Q\"},{\"area_id\":4,\"cityAbbreviation\":\"NJ\",\"cityPinyin\":\"neijiang\",\"city_code\":\"1597\",\"city_name\":\"内江\",\"city_name_en\":\"N\"},{\"area_id\":4,\"cityAbbreviation\":\"CZ\",\"cityPinyin\":\"chuzhou\",\"city_code\":\"214\",\"city_name\":\"滁州\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"FY\",\"cityPinyin\":\"fuyang\",\"city_code\":\"257\",\"city_name\":\"阜阳\",\"city_name_en\":\"F\"},{\"area_id\":4,\"cityAbbreviation\":\"SY\",\"cityPinyin\":\"shiyan\",\"city_code\":\"452\",\"city_name\":\"十堰\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"DT\",\"cityPinyin\":\"datong\",\"city_code\":\"136\",\"city_name\":\"大同\",\"city_name_en\":\"D\"},{\"area_id\":4,\"cityAbbreviation\":\"CY\",\"cityPinyin\":\"chaoyang\",\"city_code\":\"211\",\"city_name\":\"朝阳\",\"city_name_en\":\"C\"},{\"area_id\":4,\"cityAbbreviation\":\"LA\",\"cityPinyin\":\"liuan\",\"city_code\":\"1705\",\"city_name\":\"六安\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"SZ\",\"cityPinyin\":\"suzhou\",\"city_code\":\"521\",\"city_name\":\"宿州\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"TH\",\"cityPinyin\":\"tonghua\",\"city_code\":\"456\",\"city_name\":\"通化\",\"city_name_en\":\"T\"},{\"area_id\":4,\"cityAbbreviation\":\"BB\",\"cityPinyin\":\"bangbu\",\"city_code\":\"182\",\"city_name\":\"蚌埠\",\"city_name_en\":\"B\"},{\"area_id\":4,\"cityAbbreviation\":\"SG\",\"cityPinyin\":\"shaoguan\",\"city_code\":\"422\",\"city_name\":\"韶关\",\"city_name_en\":\"S\"},{\"area_id\":4,\"cityAbbreviation\":\"LS\",\"cityPinyin\":\"lishui\",\"city_code\":\"346\",\"city_name\":\"丽水\",\"city_name_en\":\"L\"},{\"area_id\":4,\"cityAbbreviation\":\"ZG\",\"cityPinyin\":\"zigong\",\"city_code\":\"544\",\"city_name\":\"自贡\",\"city_name_en\":\"Z\"},{\"area_id\":4,\"cityAbbreviation\":\"YJ\",\"cityPinyin\":\"yangjiang\",\"city_code\":\"692\",\"city_name\":\"阳江\",\"city_name_en\":\"Y\"},{\"area_id\":4,\"cityAbbreviation\":\"BJ\",\"cityPinyin\":\"bijie\",\"city_code\":\"22031\",\"city_name\":\"毕节\",\"city_name_en\":\"B\"},{\"area_id\":5,\"cityAbbreviation\":\"XG\",\"cityPinyin\":\"xianggang\",\"city_code\":\"58\",\"city_name\":\"香港\",\"city_name_en\":\"X\"},{\"area_id\":5,\"cityAbbreviation\":\"AM\",\"cityPinyin\":\"aomen\",\"city_code\":\"59\",\"city_name\":\"澳门\",\"city_name_en\":\"A\"},{\"area_id\":5,\"cityAbbreviation\":\"TW\",\"cityPinyin\":\"taiwan\",\"city_code\":\"53\",\"city_name\":\"台湾\",\"city_name_en\":\"T\"}]}";
        String cityData = "{\"citys\":[{\"area_id\":1,\"cityAbbreviation\":\"BJ\",\"cityPinyin\":\"beijing\",\"city_code\":\"1\",\"city_name\":\"北京\",\"city_name_en\":\"B\"},{\"area_id\":1,\"cityAbbreviation\":\"SH\",\"cityPinyin\":\"shanghai\",\"city_code\":\"2\",\"city_name\":\"上海\",\"city_name_en\":\"S\"},{\"area_id\":1,\"cityAbbreviation\":\"CQ\",\"cityPinyin\":\"CQ\",\"city_code\":\"4\",\"city_name\":\"重庆\",\"city_name_en\":\"C\"},{\"area_id\":1,\"cityAbbreviation\":\"TJ\",\"cityPinyin\":\"tianjin\",\"city_code\":\"3\",\"city_name\":\"天津\",\"city_name_en\":\"T\"},{\"area_id\":2,\"cityAbbreviation\":\"HZ\",\"cityPinyin\":\"hangzhou\",\"city_code\":\"17\",\"city_name\":\"杭州\",\"city_name_en\":\"H\"},{\"area_id\":2,\"cityAbbreviation\":\"NJ\",\"cityPinyin\":\"nanjing\",\"city_code\":\"12\",\"city_name\":\"南京\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"JN\",\"cityPinyin\":\"jinan\",\"city_code\":\"144\",\"city_name\":\"济南\",\"city_name_en\":\"J\"},{\"area_id\":2,\"cityAbbreviation\":\"GZ\",\"cityPinyin\":\"guangzhou\",\"city_code\":\"32\",\"city_name\":\"广州\",\"city_name_en\":\"G\"},{\"area_id\":2,\"cityAbbreviation\":\"CD\",\"cityPinyin\":\"chengdou\",\"city_code\":\"28\",\"city_name\":\"成都\",\"city_name_en\":\"C\"},{\"area_id\":2,\"cityAbbreviation\":\"WH\",\"cityPinyin\":\"wuhan\",\"city_code\":\"477\",\"city_name\":\"武汉\",\"city_name_en\":\"W\"},{\"area_id\":2,\"cityAbbreviation\":\"HEB\",\"cityPinyin\":\"haerbin\",\"city_code\":\"5\",\"city_name\":\"哈尔滨\",\"city_name_en\":\"H\"},{\"area_id\":2,\"cityAbbreviation\":\"SY\",\"cityPinyin\":\"shenyang\",\"city_code\":\"451\",\"city_name\":\"沈阳\",\"city_name_en\":\"S\"},{\"area_id\":2,\"cityAbbreviation\":\"XA\",\"cityPinyin\":\"xian\",\"city_code\":\"10\",\"city_name\":\"西安\",\"city_name_en\":\"X\"},{\"area_id\":2,\"cityAbbreviation\":\"ZC\",\"cityPinyin\":\"zhangchun\",\"city_code\":\"158\",\"city_name\":\"长春\",\"city_name_en\":\"C\"},{\"area_id\":2,\"cityAbbreviation\":\"ZS\",\"cityPinyin\":\"zhangsha\",\"city_code\":\"206\",\"city_name\":\"长沙\",\"city_name_en\":\"C\"},{\"area_id\":2,\"cityAbbreviation\":\"FZ\",\"cityPinyin\":\"fuzhou\",\"city_code\":\"258\",\"city_name\":\"福州\",\"city_name_en\":\"F\"},{\"area_id\":2,\"cityAbbreviation\":\"ZZ\",\"cityPinyin\":\"zhengzhou\",\"city_code\":\"559\",\"city_name\":\"郑州\",\"city_name_en\":\"Z\"},{\"area_id\":2,\"cityAbbreviation\":\"SJZ\",\"cityPinyin\":\"shijiazhuang\",\"city_code\":\"428\",\"city_name\":\"石家庄\",\"city_name_en\":\"S\"},{\"area_id\":2,\"cityAbbreviation\":\"TY\",\"cityPinyin\":\"taiyuan\",\"city_code\":\"105\",\"city_name\":\"太原\",\"city_name_en\":\"T\"},{\"area_id\":2,\"cityAbbreviation\":\"HF\",\"cityPinyin\":\"hefei\",\"city_code\":\"278\",\"city_name\":\"合肥\",\"city_name_en\":\"H\"},{\"area_id\":2,\"cityAbbreviation\":\"NC\",\"cityPinyin\":\"nanchang\",\"city_code\":\"376\",\"city_name\":\"南昌\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"NN\",\"cityPinyin\":\"nanning\",\"city_code\":\"380\",\"city_name\":\"南宁\",\"city_name_en\":\"N\"},{\"area_id\":2,\"cityAbbreviation\":\"KM\",\"cityPinyin\":\"kunming\",\"city_code\":\"34\",\"city_name\":\"昆明\",\"city_name_en\":\"K\"},{\"area_id\":2,\"cityAbbreviation\":\"LS\",\"cityPinyin\":\"lasa\",\"city_code\":\"41\",\"city_name\":\"拉萨\",\"city_name_en\":\"L\"},{\"area_id\":2,\"cityAbbreviation\":\"WLMQ\",\"cityPinyin\":\"wulumuqi\",\"city_code\":\"39\",\"city_name\":\"乌鲁木齐\",\"city_name_en\":\"W\"},{\"area_id\":2,\"cityAbbreviation\":\"GY\",\"cityPinyin\":\"guiyang\",\"city_code\":\"38\",\"city_name\":\"贵阳\",\"city_name_en\":\"G\"},{\"area_id\":2,\"cityAbbreviation\":\"HK\",\"cityPinyin\":\"haikou\",\"city_code\":\"42\",\"city_name\":\"海口\",\"city_name_en\":\"H\"},{\"area_id\":2,\"cityAbbreviation\":\"LZ\",\"cityPinyin\":\"lanzhou\",\"city_code\":\"100\",\"city_name\":\"兰州\",\"city_name_en\":\"L\"},{\"area_id\":2,\"cityAbbreviation\":\"YC\",\"cityPinyin\":\"yinchuan\",\"city_code\":\"99\",\"city_name\":\"银川\",\"city_name_en\":\"Y\"},{\"area_id\":2,\"cityAbbreviation\":\"XN\",\"cityPinyin\":\"xining\",\"city_code\":\"124\",\"city_name\":\"西宁\",\"city_name_en\":\"X\"},{\"area_id\":2,\"cityAbbreviation\":\"HHHT\",\"cityPinyin\":\"huhehaote\",\"city_code\":\"103\",\"city_name\":\"呼和浩特\",\"city_name_en\":\"H\"},{\"area_id\":3,\"cityAbbreviation\":\"XM\",\"cityPinyin\":\"xiamen\",\"city_code\":\"25\",\"city_name\":\"厦门\",\"city_name_en\":\"X\"},{\"area_id\":3,\"cityAbbreviation\":\"SZ\",\"cityPinyin\":\"shenzhen\",\"city_code\":\"30\",\"city_name\":\"深圳\",\"city_name_en\":\"S\"},{\"area_id\":3,\"cityAbbreviation\":\"QD\",\"cityPinyin\":\"qingdao\",\"city_code\":\"7\",\"city_name\":\"青岛\",\"city_name_en\":\"Q\"},{\"area_id\":3,\"cityAbbreviation\":\"DL\",\"cityPinyin\":\"dalian\",\"city_code\":\"6\",\"city_name\":\"大连\",\"city_name_en\":\"D\"},{\"area_id\":3,\"cityAbbreviation\":\"NB\",\"cityPinyin\":\"ningbo\",\"city_code\":\"375\",\"city_name\":\"宁波\",\"city_name_en\":\"N\"}]}";
        //把json序列化指定的对象
        CityJsonDataVo cityJsonDataVo = JsonUtils.parse(cityData, CityJsonDataVo.class);
        List<CityJson> citysList = cityJsonDataVo.getCitys();
        List<AreaVo> initAreaList = Lists.newArrayList();
        TravelStandardAreaConfig aVo;
        CityConfigVo cVo;
        AreaVo areaVo;
        for (int i = 0; i < areasList.size(); i++) {
            aVo = new TravelStandardAreaConfig();
            aVo.setOrgId(orgId);
            aVo.setAreaName(areasList.get(i).getArea_name());
            aVo.setAreaType(areasList.get(i).getAreaType());
            aVo.setHotelType(AreaTypeEnum.HOTEL_TYPE_0.getCode());
            areaConfigMapper.insertSelective(aVo);
            insertOperateLog(aVo);
            areaVo = new AreaVo();
            areaVo.setId(aVo.getId());
            areaVo.setName(aVo.getAreaName());
            areaVo.setHotelType(aVo.getHotelType());
            initAreaList.add(areaVo);
            for (CityJson cityJson : citysList) {
                if (areasList.get(i).getId().equals(cityJson.getArea_id())) {
                    cVo = new CityConfigVo();
                    cVo.setAreaId(aVo.getId());
                    cVo.setCityCode(cityJson.getCity_code());
                    cVo.setCityName(cityJson.getCity_name());
                    cVo.setCityNameEn(cityJson.getCity_name_en());
                    cVo.setCityAbbreviation(cityJson.getCityAbbreviation());
                    cVo.setCityPinyin(cityJson.getCityPinyin());
                    cityConfigService.insert(cVo);
                }
            }
        }
        return initAreaList;
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public List<AreaVo> initIntlAreaData(String orgId) {
//        String areaData = "{\"areas\":[" +
//                "{\"id\":1,\"area_name\":\"海外常用城市\",\"areaType\":\"0\"}," +
//                "{\"id\":1,\"area_name\":\"海外其他城市\",\"areaType\":\"1\"}" +
//                "]}";
        String areaData = "{\"areas\":[" +
                "{\"id\":1,\"area_name\":\"海外其他城市\",\"areaType\":\"1\"}" +
                "]}";
        //把json序列化指定的对象
        AreaJsonDataVo areaJsonDataVo = JsonUtils.parse(areaData, AreaJsonDataVo.class);
        List<AreaJson> areasList = areaJsonDataVo.getAreas();

        List<AreaVo> initAreaList = Lists.newArrayList();
        TravelStandardAreaConfig aVo;
        AreaVo areaVo;
        for (int i = 0; i < areasList.size(); i++) {
            aVo = new TravelStandardAreaConfig();
            aVo.setOrgId(orgId);
            aVo.setAreaName(areasList.get(i).getArea_name());
            aVo.setAreaType(areasList.get(i).getAreaType());
            aVo.setHotelType(AreaTypeEnum.HOTEL_TYPE_1.getCode());
            areaConfigMapper.insertSelective(aVo);
            insertOperateLog(aVo);
            areaVo = new AreaVo();
            areaVo.setId(aVo.getId());
            areaVo.setName(aVo.getAreaName());
            areaVo.setHotelType(aVo.getHotelType());
            initAreaList.add(areaVo);
        }
        return initAreaList;
    }

    @Override
    public Page page(AreaConfigVo model) {
        TravelStandardAreaConfig param = ObjectUtils.copyProperties(model, TravelStandardAreaConfig.class);
        PageContext.startPage(model.getPageNum(), model.getPageSize());
        List<TravelStandardAreaConfig> list = areaConfigMapper.list(param);
        return PageUtils.optPageBy(list, AreaConfigVo.class);
    }

    @Override
    public List<AreaConfigVo> list(AreaConfigVo model) {
        return ListUtils.copyList(areaConfigMapper.list(ObjectUtils.copyProperties(model, TravelStandardAreaConfig.class)), AreaConfigVo.class);
    }

    @Override
    public List<AreaConfigVo> getByOrgIdNotInIds(String orgId, List<Long> areaIds) {
        return ListUtils.copyList(areaConfigMapper.getByOrgIdNotInIds(orgId, areaIds), AreaConfigVo.class);
    }

    @Override
    public List<AreaConfigVo> getByOrgIdAndTsIdAndCityId(String orgId, Long cityId, Long tsId) {
        List<TravelStandardAreaConfig> travelStandardAreaConfigs = areaConfigMapper.getByOrgIdAndTsIdAndCityIdOrCityCode(orgId, tsId, cityId, null);
        //假如城市不存在任何地区，就归属在【其它地区】里面
        if (travelStandardAreaConfigs.size() == 0) {
            travelStandardAreaConfigs = areaConfigMapper.list(new TravelStandardAreaConfig().setAreaType(AreaTypeEnum.TYPE_1.getCode()).setStatus(NumberUtils.INTEGER_ZERO).setOrgId(orgId));
        }
        return ListUtils.copyList(travelStandardAreaConfigs, AreaConfigVo.class);
    }

    @Override
    public List<AreaConfigVo> getByOrgIdAndTsIdAndCityCode(String orgId, String cityCode, Long tsId) {
        //判断CityCode是城市还是国家 cityCode=cityId 名字有差异
        log.info("获取城市信息入参为,orgId:{},cityCode:{},tsId:{}",orgId,cityCode,tsId);
        HotelCityBo hotelCityBo = hotelCityDataService.searchHotelCity(cityCode);
        if(Objects.isNull(hotelCityBo)) {
            throw new CorpBusinessException(OrganizationResponseCodeEnum.CITY_NODE_PARAMS_IS_NULL);
        }
        List<TravelStandardAreaConfig> travelStandardAreaConfigs;
        if("中国".equals(hotelCityBo.getCountryName())){
            travelStandardAreaConfigs = areaConfigMapper.getByOrgIdAndTsIdAndCityIdOrCityCode(orgId, tsId, null, cityCode);
            //假如城市不存在任何地区，就归属在【其它地区】里面
            if (travelStandardAreaConfigs.size() == 0) {
                travelStandardAreaConfigs = areaConfigMapper.list(new TravelStandardAreaConfig().setAreaType(AreaTypeEnum.TYPE_1.getCode()).setStatus(NumberUtils.INTEGER_ZERO).setOrgId(orgId).setHotelType(AreaTypeEnum.HOTEL_TYPE_0.getCode()));
            }
        }else{
            travelStandardAreaConfigs = areaConfigMapper.getByOrgIdAndTsIdAndCityIdOrCountryCode(orgId, tsId, null, hotelCityBo.getCountryId());
            //假如城市不存在任何地区，就归属在【其它地区】里面
            if (travelStandardAreaConfigs.size() == 0) {
                travelStandardAreaConfigs = areaConfigMapper.list(new TravelStandardAreaConfig().setAreaType(AreaTypeEnum.TYPE_1.getCode()).setStatus(NumberUtils.INTEGER_ZERO).setOrgId(orgId).setHotelType(AreaTypeEnum.HOTEL_TYPE_1.getCode()));
            }
        }
        return ListUtils.copyList(travelStandardAreaConfigs, AreaConfigVo.class);

    }
}
